package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundUniqueGroup({
        @_DDL_CompoundUnique(name = "qbmer_qb_id", columns = {"mer_qb_id", "mer_id"})
})
@_DDL_Table(name = "qb_qb", simpleName = "", engine = MysqlDriver.InnoDB, comment = "内部户钱包")
public class _DDL_QbQb {

    @_DDL_Primary()
    @_DDL_Column(name = "qb_id", type = SqlType.CHAR, size = 20, nullable = false, comment = "钱包ID")
    private String id;

    @_DDL_Column(name = "qb_value", type = SqlType.INT, nullable = false, comment = "钱包余额，分")
    private Integer value;

    @_DDL_Column(name = "qb_state", type = SqlType.INT, nullable = false, comment = "状态，0：正常、1：冻结、2：销户")
    private Integer state;

    @_DDL_Column(name = "acc_id", type = SqlType.CHAR, size = 16, nullable = false, comment = "账号ID")
    private String accId;

    @_DDL_Column(name = "mer_id", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "商户号")
    private String merId;

    @_DDL_Column(name = "mer_qb_id", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "商户钱包号")
    private String merQbId;

    @_DDL_Column(name = "cr_date", type = SqlType.DATETIME, nullable = false, comment = "创建时间")
    private java.time.LocalDateTime crDate;

    @_DDL_Column(name = "des_date", type = SqlType.DATETIME, comment = "销毁时间")
    private java.time.LocalDateTime desDate;

}
